Notes/Domino Fix List
 |  |
| SPR # DMAE5FSKDB | Fixed in 6.0.3 release | Regression in |
Product Area: Designer Technical Area: LS Data Object Platform: Cross Platform
SPR# DMAE5FSKDB - When ODBCResultSet CacheLimit and FetchBatchSize values are equal, looping through the result set using both NextRow and IsEndOfData methods no longer skips any data rows.
Technote Number: 1090753
Problem:
This issue was reported to Lotus software Quality Engineering and has been
addressed in Domino 6.0.3 and 6.5.
Excerpt from the Lotus Notes and Domino Release 6.0.3 MR fix list (available at
http://www.lotus.com/ldd):
SPR# DMAE5FSKDB - When ODBCResultSet CacheLimit and FetchBatchSize values are
equal, looping through the result set using both NextRow and IsEndOfData
methods no longer skips any data rows.
Workaround: When both FetchBatchSize and CacheLimit are used, set
FetchBatchSize to be less than CacheLimit. For instance, in the example cited
above, if you set FetchBatchSize to be 3 when CacheLimit is 4, all the data is
returned.
Supporting Information:
The test below is based on the Employee table that is part of the SAMPLE
databases provided by DB/2. The script below queries a table called emp1 and
returns the value of the EMPNO field.
By changing the script to comment out the line:
res.fetchbatchsize = res.cachelimit
and instead set it to:
res.fetchbatchsize = 3
all data is returned.
uselsx "*lsxodbc"
Sub Initialize
Dim con As New ODBCConnection
Dim qry As New ODBCQuery
Dim res As New ODBCResultSet
'con.silentmode = True
Call Con.ConnectTo("SAMPLE","train1","password")
Set Qry.Connection = Con
Qry.SQL = "select * from lei.emp1"
Set Res.Query = Qry
res.cachelimit = DB_NONE 'internally set to 4
res.fetchbatchsize = res.cachelimit 'this skips data
'res.fetchbatchsize = 3 'this gets all data
Res.Execute
'Call Res.NextRow
Do Until res.isendofdata
Call res.nextrow
'Print "The value is " & Res.GetValue(1)
Messagebox "The value is " & Res.GetValue(1)
Loop
Res.Close(DB_Close)
con.DisConnect
End Sub
Bolded rows represent the missing data.
000010
000020
000030
000050
000060
000070
000090
000100
000110
000120
000130
000140
000150
000160
000170
000180
000190
000200
000210
000220
000230
000240
000250
000260
000270
000280
000290
000300
000310
000320
000330
000340
Related Documents:
More >
Last Modified on 05/17/2007
Go back
|